Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SGASTAT

`V$SGASTAT` displays detailed information on the system global area (SGA).

Column | Datatype | Description
--- | --- | ---
`POOL` | `VARCHAR2(12)` | Designates the pool in which the memory in `NAME` resides: `shared pool` - Memory is allocated from the shared pool `large pool` - Memory is allocated from the large pool `java pool` - Memory is allocated from the Java pool `streams pool` - Memory is allocated from the Streams pool
`NAME` | `VARCHAR2(26)` | SGA component name
`BYTES` | `NUMBER` | Memory size in bytes